﻿    /***************************************************************************************************
    **  Table:	    public.account_role
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Represents a registered account role.
    **    
    **    Use the following queries to find availables accounts and applicable roles
    **    SELECT * FROM role;
    **    SELECT * FROM account;
    **    
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial data
    ** 
    **  Status:
    **      Dev
    ** 
    ***************************************************************************************************/

	----------------------------------------------------------------------------
	-- Insert

    INSERT INTO public.account_role (account_id, role_id) VALUES (5, 1);
    INSERT INTO public.account_role (account_id, role_id) VALUES (5, 2);
    INSERT INTO public.account_role (account_id, role_id) VALUES (5, 3);
    INSERT INTO public.account_role (account_id, role_id) VALUES (5, 4);

	----------------------------------------------------------------------------
	-- Select

    SELECT * FROM public.account_role;


